SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559075 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559075 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000841,1028746,144332,178944,226739,410533,108339,20923,238110,493065,776372,777307,106631,447856,511925,102754,552440,339818,544257,801690,47226,993575,394695,743794,763754,468036,969432,662555,918718,277873,496789,638690,221381,850798,93407,20120,37825,973789,256229,143922,201790,474088,1007467,544740,577333,303779,688072,1027738,566613,266339,388613,307380,894740,953388,828526,781165,386572,806240,188033,77374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]