SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021433 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021433 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63696,1003534,246565,801934,381267,382002,939232,614050,1014877,560732,521090,1015257,889610,557027,688892,863293,790059,569120,57988,991161,466448,977484,360813,196170,416695,100821,640958,780678,297507,399831,473610,784863,229971,215823,682270,710092,964446,155185,580581,900309,528906,213553,876106,714315,665950,227161,117091,1386,484197,399784,755099,441188,197938,897290,806312,526012,1036128,898266,392490,342556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]