SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316809 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316809 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50646,429422,652317,34586,189147,296498,705489,261337,728145,652600,682881,459627,832008,970675,658333,317016,327949,379087,590608,1038513,361494,843971,689346,413522,72015,235501,274878,924972,769311,532208,158231,268346,955412,1027934,67435,333390,911205,197198,728837,664493,240268,1024802,315112,476567,324988,220156,171287,854342,888522,229800,634442,468046,588806,204041,429999,949597,153915,270488,199335,197606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]