SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381958 LIMIT 1 [ RunTime:0.001107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381958 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317130,379975,344904,1001162,568782,363393,336476,469171,741122,468989,95088,109398,930686,197446,787994,400962,1018997,863429,312161,170269,794228,166509,620121,120713,511958,565447,821346,419728,279717,898443,143905,141280,614624,418287,495906,435636,283302,732467,385021,506548,951661,144993,901527,290726,683540,914474,1016720,636714,374582,354886,470160,1026301,11404,890602,648648,522756,494970,942778,1004155,533876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002118s ]