SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501928 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501928 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288639,978554,154431,751106,150695,299584,23141,537611,782420,687186,38212,341663,532728,9823,109220,549855,141080,22695,452381,128754,160629,821518,211822,404630,166961,101608,490226,471518,286270,225293,351546,1001180,429064,447612,571660,169892,317106,362101,538615,695840,535293,530168,941690,471233,784747,228474,793520,355817,491098,717055,253482,17261,884279,349120,592597,989321,116257,453260,104395,749355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]