SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014153 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014153 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508323,661015,368988,326108,627149,887784,510637,924158,433563,179495,183317,809723,173847,330463,391616,951291,771024,351009,920414,861865,890328,757799,775931,798483,902968,323241,432332,611611,92287,101330,21489,886425,519472,890557,510715,1023553,698540,447344,649007,46362,542954,583222,741315,757275,365049,418396,846272,382304,325004,211133,435043,583781,206677,122984,840749,263422,1037550,647701,132308,626494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]