SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546220 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546220 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001848,233729,426257,774178,299227,165910,331234,510625,133366,844704,540838,225122,996320,1021860,1025850,178365,173289,492093,284919,329680,871161,941329,694909,187144,115305,226435,133564,675568,772747,841638,858892,41452,715440,1014312,905230,811781,315049,94825,153023,698251,806554,946223,670042,666681,266470,164577,335855,1002254,947543,440687,723453,76519,211015,770768,25487,423794,485949,605282,1005944,180264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]