SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195426 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195426 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524909,328349,805246,80895,194014,549913,28644,724385,189873,545526,620371,799060,489388,756561,80387,214305,970516,704068,619293,253556,823122,934880,851864,997671,227103,993966,248181,473294,317334,260446,75558,610999,781247,9375,181582,953846,430540,814519,333059,401005,157113,31342,640533,496489,262338,250572,327302,165004,587762,250822,38106,601144,80621,624822,387644,1002208,355315,367496,483824,129431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]