SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781598 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781598 [ RunTime:0.003027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894978,210693,887290,32933,192927,1009577,7173,789177,957214,31168,965192,526322,315726,387570,931894,887801,210134,562651,687743,271464,525192,905140,432515,967353,827741,402489,594704,247084,276390,303138,597635,949595,598316,296337,363299,32523,134537,341318,219278,389064,1002611,837672,995196,285556,113089,382603,585863,899292,413133,1014541,502440,12635,509814,262830,364309,1037577,252531,223231,796195,610473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]