SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580220 LIMIT 1 [ RunTime:0.000999s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580220 [ RunTime:0.003382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168485,768024,167311,33269,1029799,482425,138599,644588,820653,192041,739111,728170,188257,930119,390863,337653,712201,993398,716458,1034119,965495,835637,629482,677624,502439,560493,132063,346599,186784,944783,927989,561403,381396,834754,261081,313435,952296,357336,173167,324986,768938,790979,1020847,882111,337132,10384,270747,697363,208449,221415,633833,125013,339959,861232,848202,175706,619409,93678,263891,447902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]