SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538534 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538534 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120538,678401,416499,1007234,398042,235774,357704,87310,423171,809375,963589,584174,511503,53148,70213,461203,564936,333384,222890,459321,596401,272607,1008361,990932,725069,368066,410793,618571,610658,60708,281109,469259,156168,455543,673408,845661,247781,494582,271947,525797,961448,822643,698166,520963,313805,835845,1032284,278546,431485,77832,400972,318347,38815,159054,230502,734207,442778,767866,1047174,911867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]