SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.010787s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106089 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106089 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436186,238490,539861,969567,602685,493713,309772,1019919,122581,335170,638811,295234,675414,397026,896292,76994,28057,518695,569246,861642,717361,798948,752187,164016,309028,304488,843110,559972,296457,128454,646476,637608,220965,632688,818064,761388,431559,1020974,261999,619312,673850,161346,621208,436372,754103,881228,449344,977868,869119,565021,169646,723189,925725,996513,547515,567510,568605,356392,499198,157961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]