SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481743 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481743 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789447,542841,793814,1034504,219875,919141,279586,724156,743519,333760,69250,662914,754564,316447,971398,468153,844434,652808,43,159370,627571,233728,718715,537550,18437,150784,573016,668249,666486,445526,654949,820745,421908,751695,567640,302456,390329,901904,817249,122253,275647,294990,421611,811698,824040,307567,230570,519953,42391,599331,375072,731850,538439,569792,266004,581970,23400,813077,511274,863416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]