SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489071 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489071 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897437,146490,739971,194877,590598,240284,661511,380718,515859,939197,420648,957610,131952,119836,935044,1029827,705005,92148,419692,835744,510277,364781,446231,466308,575332,496979,307223,685417,537721,1038959,486395,199991,790570,66182,130589,334038,571812,937089,404508,164707,648678,43353,809216,940513,287305,542995,447356,906456,558271,994191,177499,162152,963086,709847,346783,43641,304122,954559,180460,465981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001256s ]