SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537893 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537893 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524601,786511,727747,865105,74632,396532,307123,14634,337511,808565,374408,1010310,317590,662189,831679,948390,321529,364788,737371,612149,1000153,966646,262300,182850,357333,40655,472633,409228,821736,76518,669346,717461,935289,114352,260764,777371,392104,2394,148621,76459,690468,791236,809949,945589,758555,746252,675413,788043,929120,96774,126350,54772,342575,597300,457967,710042,677105,628149,842300,32895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]