SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493053 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493053 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300216,509980,457660,4340,883719,818804,218520,889312,110280,151530,415213,687126,940280,860492,1043508,223985,773287,790278,497042,989161,471769,796144,803571,233871,970394,550310,929995,863970,730318,900242,393851,733610,850779,898931,661318,1019560,1015630,688754,360995,376577,463815,234083,425212,1026415,220562,802876,169230,11941,1005449,298928,747055,918398,321274,849376,770902,842251,851102,576782,991792,994919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]