SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281027 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281027 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016749,503253,922304,537417,105580,38787,825439,26936,723287,34213,109857,349713,238888,228597,78853,210239,798772,79415,587784,274483,1037723,84029,790228,953941,895259,1014844,513944,1021479,346044,517790,431031,1047430,275938,947500,349822,1003293,591549,632719,437668,799172,703357,603012,373960,783351,167892,240087,827602,919488,533270,932959,4230,721951,498923,154233,647794,163190,395861,993516,523864,171116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]