SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019140 LIMIT 1 [ RunTime:0.004516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019140 [ RunTime:0.003181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312301,138186,393678,60344,310074,865765,374881,340466,12053,58541,714555,1021530,594416,460655,945715,1018823,323927,902482,347307,838448,447393,908169,338938,605897,35696,798979,212956,860763,933749,105728,941386,801491,872801,414900,1035336,2796,817029,31852,166219,327194,485012,1001559,567689,712771,630052,409218,948566,440068,786614,453333,542574,817322,857458,258358,225393,700380,493131,54083,184194,648499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001407s ]