SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543283 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543283 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460978,759290,275197,10052,950586,551412,951320,246583,869053,339032,354312,750826,898678,726897,301501,953688,169789,452063,281115,974832,167543,545834,151572,87693,654838,374873,1002868,111191,920127,363606,344046,533695,176981,41826,756240,452896,914400,313365,805873,567518,708679,53259,196354,744618,454909,1036185,228607,922529,617507,303245,900488,258835,288627,589673,67719,505518,633325,250778,708240,1025895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]