SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545416 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545416 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206430,375611,975173,278980,207842,110766,405553,653771,760589,965523,680429,741450,777053,601315,122182,845604,653812,677708,799006,326246,414688,1017892,813524,322894,1026205,567174,812158,909677,15172,190492,344301,785938,984733,397323,679125,1015537,908679,355069,881631,632361,253007,779670,297996,778652,839207,512172,464568,439874,118858,809364,586638,461803,159626,91924,390454,142893,577582,93248,50218,278474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]