SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437039 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437039 [ RunTime:0.006159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578664,25928,1029855,524416,410219,711037,180118,784735,417853,928004,923768,198586,26356,282824,625322,280606,928202,682464,481834,639305,1047981,312582,574344,442185,133974,1010821,1001562,915434,221164,529245,564526,715313,617970,635353,488849,804243,955394,209873,644986,921243,379248,463272,763478,207503,761175,692443,497520,659860,994842,979453,178051,431680,293946,283268,852980,193306,341325,144125,51294,1008131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]