SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671453 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671453 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404590,214266,143582,275622,207030,1010752,1000356,969779,645204,338448,117021,673973,132822,936156,254055,1002493,860953,633208,62216,652781,994243,107782,863827,358188,556128,88040,716901,826408,258956,666553,1010348,594292,516433,174650,699768,95421,474026,795557,683646,753204,767275,222042,860881,951637,1038959,751702,588682,243374,652355,591666,1021841,241058,1009833,792613,718427,832795,159595,854210,675030,778952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]