SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438603 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438603 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446035,631892,727290,395244,289491,110159,208385,697347,608126,166148,786943,401440,692064,340553,439877,251336,233156,184284,333687,923297,13988,634205,146136,581324,224005,666603,669055,677403,462976,29210,580400,1004854,1023618,483463,488517,1034471,145582,787493,668048,772789,523197,404071,300201,1005430,672327,599983,269320,432839,132853,642983,42178,451838,268775,579010,190208,133149,379599,773230,481356,243153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]