SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028035 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028035 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300630,247275,915511,964029,885964,188170,846956,99266,157679,386793,420499,149254,743007,58261,444432,281974,641462,195798,389905,236628,507802,31378,230834,165192,457509,702454,372227,652309,692755,1022217,569863,23191,681634,495195,313804,723939,16324,222612,501198,247760,796026,777837,442264,383068,899074,535517,987625,969666,953009,993573,156631,16465,300764,508142,107565,242963,968369,278803,823426,541954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001900s ]