SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403900 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403900 [ RunTime:0.003288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197840,213546,564414,690010,414647,194127,520612,491756,214785,299922,446221,149469,1004898,281301,628984,629396,430207,436731,515413,746110,442635,622068,658222,227016,986064,19458,210599,1043389,219382,366197,670788,240953,690809,1022169,688599,983589,898379,109862,9952,385447,146158,945645,642924,584429,985064,196595,278454,331186,459422,264209,117316,169402,14267,778130,184723,615023,185735,254274,151634,567796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000840s ]