SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010697 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010697 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72398,459957,23421,180163,1021327,849359,91776,493781,18278,947511,446832,190305,460785,83944,106975,966071,753258,941727,899399,664138,778047,882581,717429,158942,660173,370313,653879,936407,670832,786496,433379,767557,134821,414177,251470,941881,136460,528349,155594,67883,344320,31080,794955,628942,185940,433744,478661,644463,480821,169673,589739,621835,570142,540654,885348,121313,1029583,740969,221234,81247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]