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` = 542748 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542748 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486821,771566,797893,133087,671685,657022,371646,644252,475383,445418,1012469,559024,364232,871446,222449,721938,1027119,760678,907071,383264,190240,582048,739989,975124,525548,88148,392437,130867,232537,863350,570990,1026107,933927,943867,297374,891158,670529,1001840,591892,508688,816096,480650,111670,866964,288627,133410,79111,839415,795012,353231,850537,418782,460429,335632,290077,954806,879119,204957,264703,355520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]