SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508513 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508513 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171724,468481,294610,415972,423037,512425,531708,40157,859228,706480,232556,273802,155387,625397,545192,852324,451157,276751,8303,408304,232233,896655,624981,328105,237184,934715,406677,597418,691242,736746,112987,452750,494553,323292,773441,235100,89366,187320,604886,713685,954004,69849,1010154,506588,932469,437004,99484,235811,143059,114783,976807,355244,921720,719566,415614,699398,238056,400806,684902,187937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]