SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478910 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478910 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564760,879492,607332,172181,885943,101036,679630,314398,972161,524087,473409,877300,890733,356142,808061,862843,493022,193692,465279,509865,338248,532347,161947,547052,735240,48597,997555,91534,660138,91989,101103,727711,123569,852848,964600,353498,850531,236018,783242,828526,745555,456216,663629,254932,106399,930618,704050,208955,281309,854660,124898,768345,390685,386224,786754,392133,699644,420809,356491,172818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]