SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529252 LIMIT 1 [ RunTime:0.000788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529252 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406066,508652,168194,766449,531844,697560,905672,535573,897969,543148,918839,437814,729025,634913,20328,572771,285258,748142,977382,439772,623153,118537,678772,924622,400043,150650,177601,787153,519106,280619,403286,168719,602075,662900,807043,385939,549266,438491,893316,288623,859232,913291,1045127,153944,666566,307665,250518,430507,957767,37001,490406,1015017,494281,331058,648915,854803,871147,943818,29064,849231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001310s ]