SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341504 LIMIT 1 [ RunTime:0.000850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341504 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27990,440781,647354,210947,45499,606234,568155,903390,84984,354375,382298,967030,671060,126083,890240,609010,611555,232779,243863,685775,886331,442893,788583,100987,114969,617705,635632,72604,232693,376308,504159,1045149,804952,544664,540747,543746,605181,195046,899378,538805,692672,188220,219483,509760,1012357,499018,615712,817863,896901,789638,529356,323185,150756,991326,361316,717509,840345,62522,231925,1030316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]