SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403284 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403284 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193585,1008940,867608,609519,351184,740320,111634,78315,214393,1048254,532759,482986,448892,706739,899277,746096,410645,1513,138763,595579,734532,322547,201554,523482,315877,292700,445285,994319,569106,50325,197636,935701,500188,390094,888099,857958,800382,761860,1021360,701962,101358,1046620,1028032,239835,97984,705959,11008,202191,691920,549517,690863,89427,475044,612703,610219,651000,459567,853680,1027402,546317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]