SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327249 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327249 [ RunTime:0.003007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611014,793024,670610,566471,134103,1005711,359544,304183,673785,732699,470879,1031816,343794,149202,535595,232659,1005387,637722,258131,155513,617506,238556,49288,319812,203465,696315,565263,998075,367863,520068,372642,96503,466053,673030,981417,831088,87547,188500,756564,856343,320964,400888,446656,775772,254885,524396,158913,392105,37949,420512,539496,547479,80002,350958,828093,86660,285951,178103,938747,423924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]