SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498608 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498608 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254505,297325,274835,707663,308188,704499,487926,806795,184899,866015,360829,181418,1016972,835694,467049,246809,818218,463222,677707,829873,804371,317685,158518,275413,693823,685563,436495,668120,853826,907246,1014751,70543,169946,289862,437118,976108,895726,773286,178494,585148,385504,436543,88456,484837,42220,348430,255164,436187,180242,150340,820898,329539,437982,987351,1002047,477279,713178,1022800,37343,1042712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]