SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464303 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464303 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007032,738140,472365,936233,90778,386795,251467,92002,928714,585799,531664,304594,659083,390750,792980,521687,919271,130348,161196,403353,564921,609507,60140,37255,104632,359181,550319,556883,385873,17283,299500,423733,462992,997963,68421,536658,510982,387845,842943,169313,170944,489282,1037461,44198,1017742,667416,62181,515250,589865,677692,792218,809521,521979,657289,35952,472648,447272,428287,679891,652900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]