SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266671 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266671 [ RunTime:0.003824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853497,997420,479655,6673,251895,1009573,298828,38610,591264,290014,108952,609123,602413,821243,1009828,86844,377517,635697,996268,673681,14450,513720,343903,1015460,593988,107776,470531,1038569,768997,902114,404754,390284,863592,610026,199014,774520,450997,572526,140218,280603,9403,247957,94709,701121,617666,556935,70758,292646,606191,667013,972410,61127,201878,172464,176381,232921,939333,242622,887741,610440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]