SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048188,625744,115040,387711,1015181,646439,1198,88682,851699,29542,733166,890214,745240,3309,918670,461200,389777,543081,240001,52330,46800,87633,815931,122763,700590,26826,677808,143939,256418,534154,85587,909072,739141,691245,89624,168676,434103,229439,483411,608406,144919,529904,315982,1017563,220881,533531,692690,479605,929800,330128,845059,385818,1026958,418765,23998,173589,557359,339297,167103,276789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]