SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336060 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336060 [ RunTime:0.003382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032156,143818,898666,690072,119270,232582,621028,956129,850371,883768,1008920,19897,384875,785003,110634,997611,185060,900219,792917,555180,715791,631104,268188,236307,796248,132454,1019582,988046,814614,85978,28965,84718,411473,699397,941764,446881,285232,256652,26106,622562,712740,315663,770265,1001575,439165,844323,368211,354446,812705,243486,99893,191572,428340,102129,69826,661146,403231,917053,227464,712671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]