SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505587 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505587 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110600,796933,695421,1024756,502154,354245,263195,651751,120921,629946,878973,712820,802570,150316,691642,697498,401762,791248,349619,2738,475953,396997,20386,852793,614731,800974,873058,129729,371066,1012477,839854,634998,760244,1029900,622351,438854,115337,916696,869855,1002085,289241,1029079,1023299,924911,971232,98641,204799,591965,1005167,632325,70572,650930,510037,632896,313137,453203,578833,109244,952790,597516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505587 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505587 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]