SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542012 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542012 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715445,613471,159380,89453,839626,17958,441620,104982,940774,808586,110542,262555,770404,237493,665385,200751,242804,644167,827538,332210,939963,197188,609600,564390,112352,640183,284323,31407,1026130,318396,369908,746866,498034,784386,89564,803920,352476,450040,589023,14209,321292,896075,165355,729207,303784,883524,671940,635133,532450,120148,300885,456862,488652,139208,35764,712728,355610,12371,539644,755464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]