SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102099 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102099 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257002,956641,850151,786873,152602,848906,420650,564280,273587,368689,1020287,310342,109509,618370,46001,658124,353009,873797,189850,820129,923204,934953,194994,1011366,863989,943648,1019057,259780,10583,675873,473679,651541,188917,590647,428830,413032,56388,716714,538504,15295,581070,189014,1012084,358023,641208,397850,486867,1043962,596632,411604,783322,933102,589039,597498,509228,695445,460974,990534,839920,25152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]