SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266561 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266561 [ RunTime:0.005539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284779,850930,570281,551016,331027,896183,683398,44076,647039,920633,260817,485839,798900,642502,117298,935184,924389,1013679,943377,986245,164019,441755,1041313,922491,363994,763511,450067,804921,686641,345693,793283,773746,609900,441713,293421,538877,714063,478011,721671,74887,84183,398538,608880,977702,346924,251698,320380,190589,967148,912650,767324,650319,987423,234762,70897,830272,822199,213283,200991,218963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001772s ]