SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528873 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528873 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64009,396852,238169,717019,428129,422145,414599,754705,720283,174679,877471,393445,84210,289015,606254,7259,894805,1001002,889436,627125,74001,436876,572771,109698,523571,810839,470642,144083,360237,770163,592971,253972,626558,49045,285872,977375,840952,886184,886239,160533,305695,757064,2655,950623,206192,205763,3554,1006016,790746,914020,94695,863863,190951,549936,741746,150235,80012,526346,609405,407759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]