SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473022 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473022 [ RunTime:0.002643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547184,935105,1036208,329376,449116,73404,807495,1025081,752696,851158,269220,284516,140422,596805,158233,659410,1034381,305663,541535,109200,685710,284688,559843,890884,679439,637237,223135,636161,880822,410572,365554,448298,470586,844958,541943,535015,41592,148862,284950,922371,451427,1007997,897397,302949,496456,150598,685662,1732,138820,1045296,257970,610154,455677,78409,769666,803341,337363,329424,774580,267633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]