SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400786 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400786 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485633,822336,278223,686704,989646,641107,399633,846827,59898,262530,359107,852144,352468,959512,354053,720383,765628,79951,704682,270999,780803,315668,809074,383749,27813,673168,1031677,416603,53125,237966,503689,1017251,553072,213030,112826,749929,782076,1048582,825447,987907,437561,783403,428029,397715,771548,598675,59380,992549,224886,1015738,24354,154275,829432,294176,442902,339735,805654,653177,520901,941360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]