SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105346 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105346 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518049,77641,647343,980453,27018,31926,573811,485782,644978,521316,127384,582111,492892,736818,20208,228858,343310,897649,381736,849474,65139,500918,282836,256825,830461,577715,152873,388163,1030355,91358,589487,499880,127852,399345,459432,1028010,712725,239714,467918,327250,250187,560226,1046680,226547,272789,971847,214598,470319,874126,882833,553449,510774,977960,951337,730100,7221,55502,541395,259266,860177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]