SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501433 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501433 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413270,617615,882205,704804,953567,187864,691487,1033604,201048,710910,588551,85425,885994,917616,488534,97672,716181,440506,133932,502718,968779,320935,967515,831751,437057,447526,1000807,267357,981904,705662,956090,298720,601913,37530,689986,173902,946547,355938,834292,793072,960188,544246,297253,487522,807495,812936,1035765,725603,575195,456368,429600,739124,170007,140163,1048612,387137,95059,383548,89350,1018950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]