SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101512 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101512 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497320,577754,123882,662643,515535,959070,759611,315226,922339,411305,806704,29235,20157,641675,811575,970033,851300,413145,942195,13582,364943,288830,527549,871192,433541,845992,15242,670433,646671,913261,518633,883553,1019439,160062,36606,218311,33631,527039,806015,538735,39806,745598,585706,720540,901146,534510,230920,357720,515592,260208,959331,162456,898335,1021591,395747,392567,472440,594635,639657,643973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]