SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550076 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550076 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11347,148931,524052,804510,594822,745978,77955,640677,596533,827857,327298,658861,140061,380214,550220,699711,363884,461079,533837,113705,377030,1039588,782815,617521,704868,754036,565411,57340,916141,600472,667173,530563,835232,867176,673997,609138,45044,992726,1012268,519707,188314,818191,260411,80198,871779,707431,189918,1037283,256966,658184,331788,91943,1023094,81087,562921,354324,488710,34598,346730,595045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]