SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801399 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801399 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559283,795212,225458,970670,93194,969276,130701,513162,980538,213480,551475,251154,375716,410733,53343,757016,800381,437817,737628,751915,198893,853430,380734,431560,289703,643178,953690,190868,872280,361527,468785,661645,327824,366896,765099,775039,458535,72439,817927,863783,472265,137184,341941,370866,41975,867497,759654,702355,466852,361744,242585,973076,246960,320959,939686,760005,1047992,235355,837925,725679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001369s ]