SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144583 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144583 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719525,354303,218631,239171,855114,404549,30934,452510,704210,779149,819087,841889,434808,254082,936381,656296,947680,650177,968383,112916,477778,217890,456505,711061,687364,666705,773444,440245,1008979,500043,334379,727767,15639,88182,158730,954158,161585,223849,272453,272816,503428,803387,4363,968862,45167,221130,141954,91391,800394,352610,771633,21006,251494,502879,570288,790172,787107,305149,171383,54236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]