SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506459 LIMIT 1 [ RunTime:0.000619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506459 [ RunTime:0.002806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976059,453757,330662,580819,734078,104077,256906,230104,850918,547096,871280,901444,718026,675252,164028,390426,860089,25094,711539,976695,201553,979920,44269,141961,876679,126646,767559,57827,455659,829828,679918,871357,505844,760401,926998,461491,158030,475800,996691,636252,172032,156578,348887,302439,510,295555,131931,414546,894431,849511,237018,988974,776401,294196,468755,938782,101386,928227,73105,847043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]