SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429105 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429105 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308755,241565,120161,507330,352328,114618,962154,997636,640413,829888,302207,534664,523778,964825,508512,952259,345269,652257,1034620,420724,472781,155245,42482,129999,846655,903992,275099,239489,137325,610374,534711,740056,568029,333364,685917,630127,89883,873160,70347,272035,680912,666029,22299,570767,495392,754918,944738,148310,963008,880096,214807,999518,134843,213857,834071,532232,354292,554997,694866,388893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]