SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443611 LIMIT 1 [ RunTime:0.002436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443611 [ RunTime:0.012465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691411,1029035,804757,456423,723853,104416,949765,822792,565538,443744,426639,924397,554619,790369,192782,825682,907558,173879,709246,196408,267813,850555,526615,901146,166771,712776,277527,880118,461184,986375,733177,290453,798786,599574,407369,834868,862652,2239,960806,639026,824051,201257,295378,324911,1032527,48149,203880,763390,602776,94781,809390,338903,469368,534720,92056,9544,570802,515243,829241,970213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]