SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530894 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530894 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040439,498584,416469,731353,677671,989690,646403,665399,355068,758580,70003,352130,16216,1034803,523521,105935,373308,672426,191806,337293,574928,233098,464717,312522,452089,457482,530220,34786,55009,833014,1008786,823509,479695,300608,407333,1037040,825657,102326,431620,138053,892938,411517,246411,963217,542934,208660,255654,293058,1010084,6042,24844,441107,268927,1868,188254,856024,836415,914353,599692,953562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]