SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033110 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033110 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142849,281712,179305,923892,304835,903330,984713,705093,469700,164799,632559,23519,649773,826549,528531,230517,459435,1037032,1045864,988441,1034328,904338,503739,162144,926453,114969,229087,956618,826516,387176,290541,852057,682778,103066,769319,851594,386610,359374,782546,1037329,130375,598787,754746,178380,72790,997853,612548,897607,905825,957612,452111,146298,279768,774545,986802,275575,120353,980758,659782,447256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]