SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021537 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021537 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934180,469199,637613,32663,888035,170129,691732,14651,687983,937949,12262,727345,691193,534800,287393,650382,219054,983217,777484,465320,195275,824191,413164,1043047,1007750,424457,938542,149229,876870,85857,927366,1023836,1016455,708177,168236,516157,955910,849281,88301,249452,843206,333383,46804,919687,389581,220771,605329,688713,607673,855010,482934,118841,976541,650413,307082,244458,693736,382062,129190,334603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021537 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021537 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]