SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47653 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47653 [ RunTime:0.003911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540965,610247,758747,615333,118354,590918,1032731,1019005,961392,141031,714503,224603,380449,557438,249493,145078,640127,995458,116434,186321,979814,459088,838654,231009,483863,47805,723189,954624,33953,274162,1011128,327281,8559,1031789,810625,840585,772877,696312,791793,238724,641156,244488,667405,600554,280908,397043,508387,949590,465903,167669,568867,620803,733736,554806,766134,804880,486714,265641,9126,708402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]