SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007547 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007547 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215050,399614,633351,416502,185221,708922,238310,41799,374006,234183,643505,507600,813305,253850,724391,431012,997105,313115,863978,301971,933858,171039,139829,28508,102818,808220,597047,40517,448557,148231,143844,455717,348086,299836,24311,830462,417521,534973,70468,578269,733210,45756,760644,318072,293941,729150,880007,309220,830632,93534,185338,15760,825977,704982,328020,183605,253570,442918,585665,561768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]