SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588959 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588959 [ RunTime:0.003045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709416,768448,705003,974954,503166,280002,95779,562515,129734,321095,164020,877796,133480,738447,984996,521509,299387,986437,267390,34158,555591,846281,527597,1043761,33456,625099,973391,876303,753144,734463,977859,32134,924600,1043181,322197,526453,476748,618759,218668,746581,47072,257939,361675,530084,472051,879870,932676,158915,887001,925313,355937,742147,755702,902177,592810,684609,387595,33974,586947,530163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]