SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528441 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528441 [ RunTime:0.003917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368717,405281,939281,159592,773213,978117,485992,110002,375731,895734,797798,700593,157802,512298,678835,938585,661441,64334,500773,1020124,260637,860042,152439,938563,259422,1043317,478273,253014,673076,731633,799879,199741,310055,184104,790696,545891,36524,770855,225889,419400,762110,413297,668460,914037,310124,728246,387498,347861,636601,25331,945335,147307,684512,981925,494913,293688,214878,441043,605051,162796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]