SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321083 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321083 [ RunTime:0.007539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147979,907348,489991,864490,999599,751308,1005126,241052,878896,686198,1029912,452649,347141,567231,115825,278774,738695,582521,406000,300656,310376,144354,311637,232810,595456,651625,586378,148586,338795,587793,367371,99101,607663,179395,622765,326832,181731,792940,909527,42536,802376,191818,330100,417212,683973,193208,836725,243309,267437,480187,445935,678111,388098,27596,877989,494071,369605,921449,603057,906483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]