SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269442 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269442 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368170,194885,512312,972185,822215,705376,435915,281080,362178,667667,676598,415564,283464,321060,628423,878936,249478,134271,112024,870092,564014,176674,102107,199232,669698,413643,691491,772962,88338,391113,799710,413447,192080,385386,503255,112529,749535,1012568,224985,970274,47707,187673,14557,367909,238993,254707,271711,137933,786344,340509,26273,667584,444098,1014741,1047755,851824,175920,112376,481535,112029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]