SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329740 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329740 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274970,886921,181463,402220,1027981,171759,447853,772355,659453,366597,907586,407272,894534,277201,1020511,353465,264355,70813,504084,932056,984118,922657,536809,281979,256189,916557,450875,514964,196454,178108,470925,452941,232644,106636,664747,1024988,839634,528232,1046635,515963,965993,867929,231432,4027,77865,587514,171292,347672,937838,27670,570380,122989,928291,468553,386504,1042368,745571,6519,938978,145416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]